﻿CREATE PROCEDURE [dbo].[pokemons_insert]
    @name nvarchar(256),
    @height int,
    @weight int,   
    @element int,
    @parentId int
AS
    Insert Into Pokemons
        (Name, Height, Weight, Element, ParentId)
    Values
        (@name, @height, @weight, @element ,@parentId)

    Declare  @pokemonId int = @@IDENTITY

    SELECT PokemonId, Name, Height, Weight, Element, ParentId From Pokemons 
    Where PokemonId = @pokemonId
RETURN 0
